use "Table1Data.dta" 


*******************Generate Table 1**********************

ssc install estout
estpost tabstat  , by (year)  stat(mean sd) nototal
esttab, cells("mean sd min max") nomtitle nonumber noobs

eststo clear
by year: eststo: quietly estpost summarize Cotton_intensity corn_intensity wheat_intensity TOTHARVESTAREA Percent_Tenant AVG_FARMSIZE, listwise 

esttab using "Table1_sum.tex",  main(mean) aux(sd) label replace mtitles nonote noobs title("Summary Statistis by Census Year")

